export default{
	db: {
		'dbName': 'iDOCK'
	},
	createTableSql: {
		'describe': [
			[
				'create table if not exists im_conversation(',
				'conversation_id CHAR(50) NOT NULL,',
				'conversation_name CHAR(50) NOT NULL,',
				'conversation_avatar CHAR(256) NOT NULL,',
				'conversation_type CHAR(20) NOT NULL,',
				'is_at_all TINYINT(4) NOT NULL,',
				'is_top TINYINT(4) NOT NULL,',
				'unread INT(11) NOT NULL,',
				'last_message_id CHAR(50) NOT NULL,',
				'last_message_group_id CHAR(50) NOT NULL,',
				'last_message_type CHAR(20) NOT NULL,',
				'last_message_timestamp BIGINT(20) NOT NULL,',
				'last_message_status CHAR(20) NOT NULL,',
				'last_message_sender_id CHAR(50) NOT NULL,',
				'last_message_sender_name CHAR(50) NOT NULL,',
				'last_message_recalled TINYINT(4) NOT NULL,',
				'last_message_read TINYINT(4) NOT NULL,',
				'last_message_text TEXT NOT NULL,',
				'last_message_content_type CHAR(50) NOT NULL,',
				'last_message_height INT(11) NOT NULL,',
				'last_message_width INT(11) NOT NULL,',
				'last_message_size INT(11) NOT NULL,',
				'last_message_name CHAR(50) NOT NULL,',
				'last_message_url CHAR(128) NOT NULL,',
				'last_message_duration NUMERIC(10,2) NOT NULL,',
				'PRIMARY KEY (`conversation_id`)',
				');'
			],
			[
				'create table if not exists im_conversation_message(',
				'message_id CHAR(50) NOT NULL,',
				'receiver_id CHAR(50) NOT NULL,',
				'sender_id CHAR(50) NOT NULL,',
				'sender_name CHAR(50) NOT NULL,',
				'sender_avatar CHAR(128) NOT NULL,',
				'timestamp BIGINT(20) NOT NULL,',
				'message_type CHAR(20) NOT NULL,',
				'message_recalled TINYINT(4) NOT NULL,',
				'message_status CHAR(20) NOT NULL,',
				'message_read TINYINT(4) NOT NULL,',
				'payload_text TEXT NOT NULL,',
				'payload_content_type CHAR(50) NOT NULL,',
				'payload_height INT(11) NOT NULL,',
				'payload_width INT(11) NOT NULL,',
				'payload_size INT(11) NOT NULL,',
				'payload_name CHAR(50) NOT NULL,',
				'payload_url CHAR(128) NOT NULL,',
				'payload_duration NUMERIC(10,2) NOT NULL,',
				'payload_video_url CHAR(128) NOT NULL,',
				'payload_thumbnai_url CHAR(128) NOT NULL,',
				'payload_path CHAR(128) NOT NULL,',
				'video_content_type CHAR(50) NOT NULL,',
				'video_height INT(11) NOT NULL,',
				'video_width INT(11) NOT NULL,',
				'video_size INT(11) NOT NULL,',
				'video_name CHAR(50) NOT NULL,',
				'video_url CHAR(128) NOT NULL,',
				'video_duration NUMERIC(10,2) NOT NULL,',
				'thumbnail_content_type CHAR(50) NOT NULL,',
				'thumbnail_height INT(11) NOT NULL,',
				'thumbnail_width INT(11) NOT NULL,',
				'thumbnail_url CHAR(128) NOT NULL,',
				'PRIMARY KEY (`message_id`)',
				');'
			],
			[
				'create table if not exists im_merge_message(',
				'mid INTEGER PRIMARY KEY AUTOINCREMENT,',
				'message_id CHAR(50) NOT NULL,',
				'merge_id CHAR(50) NOT NULL,',
				'receiver_id CHAR(50) NOT NULL,',
				'sender_id CHAR(50) NOT NULL,',
				'sender_name CHAR(50) NOT NULL,',
				'sender_avatar CHAR(128) NOT NULL,',
				'timestamp BIGINT(20) NOT NULL,',
				'message_type CHAR(20) NOT NULL,',
				'message_recalled TINYINT(4) NOT NULL,',
				'message_status CHAR(20) NOT NULL,',
				'message_read TINYINT(4) NOT NULL,',
				'payload_text TEXT NOT NULL,',
				'payload_content_type CHAR(50) NOT NULL,',
				'payload_height INT(11) NOT NULL,',
				'payload_width INT(11) NOT NULL,',
				'payload_size INT(11) NOT NULL,',
				'payload_name CHAR(50) NOT NULL,',
				'payload_url CHAR(128) NOT NULL,',
				'payload_duration NUMERIC(10,2) NOT NULL,',
				'payload_video_url CHAR(128) NOT NULL,',
				'payload_thumbnai_url CHAR(128) NOT NULL,',
				'payload_path CHAR(128) NOT NULL,',
				'video_content_type CHAR(50) NOT NULL,',
				'video_height INT(11) NOT NULL,',
				'video_width INT(11) NOT NULL,',
				'video_size INT(11) NOT NULL,',
				'video_name CHAR(50) NOT NULL,',
				'video_url CHAR(128) NOT NULL,',
				'video_duration NUMERIC(10,2) NOT NULL,',
				'thumbnail_content_type CHAR(50) NOT NULL,',
				'thumbnail_height INT(11) NOT NULL,',
				'thumbnail_width INT(11) NOT NULL,',
				'thumbnail_url CHAR(128) NOT NULL',
				');'
			]
		],
	},
}